package cn.ecut.dao;


import cn.ecut.model.Alumni;
import cn.ecut.model.Scholarship;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ScholarshipDao {
    List<Alumni> selectAllAlumni();
    Integer addScholarship(Scholarship scholarship);
    List<Scholarship> selectAllScholarship(@Param("offset")int offset, @Param("num")int num);
    Integer selectAllcount();
    Integer updataScholarship(Scholarship scholarship);
    Integer selectResiduBySid(Integer sid);
    Integer selectSumBySid(Integer sid);
    Integer deleteBySid(Integer sid);
    List<Scholarship> advanceSelect(@Param("s") String s,@Param("offset")int offset,@Param("num")int num);
    Integer advanceSelectCount(String s);
    Scholarship selectDetailScholarshipBySid(Integer sid);
}
